Original Column Name |
Expanded Column Name |
Description |
AuditTrailEntryID |
Audit Trail Entry Details |
Unique identifier for each entry in the audit trail documenting changes or actions performed within the system. |
AuditLogID |
Audit Log Details |
Reference to the specific audit log record that this entry belongs to, indicating the broader context of the audit event. |
PKID |
PKID |
Primary Key ID; the unique identifier for the primary key of the record that was affected by the event being audited. |
PKName |
PKName |
Primary Key Name; the name of the primary key column of the record that was affected in the auditing event. |
RecName |
Rec Name |
Record Name; the human-readable name or description of the record that was accessed or modified. |
TableName |
Table Name |
The name of the database table that contains the record being audited, which indicates where the event occurred within the system's data structure. |
TypeID |
Type Details |
Type ID; an identifier that classifies the type of event that was audited, such as creation, modification, deletion, or access. |
ZUChkSum |
ZU Check Sum |
Zero Usage Check Sum; a cryptographic checksum used to verify the integrity of the data associated with the audit record for security and data corruption detection purposes. |
ZUDate |
ZU Date |
Zero Usage Date; the date and time when the audit entry was recorded or processed, used for tracking and historical analysis. |
ZULogonHisID |
ZU Logon History Details |
Zero Usage Logon History ID; refers to the identifier of the user's logon session that is related to the audit event, providing a linkage to the user who initiated the change. |